Hệ thống quản lý trường học bằng PHP / MySQLi
1
2 <?php
3 include("connect.php");error_reporting(0);
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8
9 <!DOCTYPE html>
10 <html>
11
12 <head>
13 <meta charset="utf-8">
14 <meta name="viewport" content="width=device-width, initial-scale=1.0">
15 <title>school management system</title>
16 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
17 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
18 <link href="assets/css/loader.css" rel="stylesheet" />
19 <script src="assets/js/canvasjs.min.js"></script>
20 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
21 <script src="assets/js/jquery-3.2.1.js"></script>
22 </head>
23
24 <body >
25 <!--end of heading section-->
26 <ul class="nav navbar-right top-nav">
27 <div class="dropdown">
28 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
29 <?php
30 //Check to see if the user is logged in.if not redirect user to the loging page.
31
32 if(isset($_SESSION['fname']))
33 {
34 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
35 }else{
36 echo "<script type='text/javascript'>
37 alert( 'You must Log in to use the system');
38 </script>";
39 echo "<script>
40 window.location = 'index.php'
41 </script>";
42 }
43 ?>
44 <span class="caret"></span></button>
45 <ul class="dropdown-menu">
46 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
47 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
48 <li class="divider"></li>
49 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
50 </ul>
51 </div>
52 </ul>
53 <!--************************************************-->
54 <div style="
55 font-family:Nyala, Arial;
56 text-align: left;
57 background-color: #526F35;
58 padding: 20px;
59 color:white;
60 width: 100%;
61 height: 150px;">
62 <!--This codes to load the image loader-->
63 <div id="loading">
64 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
65 </div>
66 <!--this is the heading section-->
67 <h2>
68 <?php
69 $sql="SELECT * FROM companyinfo";
70 $result=mysqli_query($db,$sql) or die("error getting data");
71 $num_rows=mysqli_num_rows($result);
72 while($row=mysqli_fetch_array($result))
73 {
74 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
75 $cname = $row['cname'];
76 $cemail = $row['cemail'];
77 $ccontact = $row['ccontact'];
78 $clocation = $row['clocation'];
79 }?>
80 <?php
81 echo $cname;
82 ?>
83
84 <div style="float:right; font-size:20px;text-align:right;">
85
86 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
87 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
88 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
89
90 </div>
91 </h2>
92 </div>
93 <!--end of heading section-->
94
95 <div>
96 <ul class="nav nav-tabs">
97 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
98 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
99 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
100 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
101 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
102 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
103 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
104 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
105 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
106 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
107
108 </ul>
109 <div class="tab-content">
110 <div class="tab-pane active" role="tabpanel" id="tab-1">
111
112 <p>
113 <div class="table-responsive" >
114 <!--****************************************************************************-->
115
116 <div class="container" style="width:100%">
117
118 <ul class="nav nav-tabs">
119 <li ><a href="feestudents.php">Students List<img src="assets/img/new.png"> </a></li>
120 <li class="active"><a href="paymentlog.php">Payment Log<img src="assets/img/new.png"> </a></li>
121 <li ><a href="csvfee.php">Import/Export CSV<img src="assets/img/export.png"></a></li>
122 <li ><a href="printfeeinvoice.php">Print Invoice<img src="assets/img/print.png"> </a></li>
123 <li ><a href="fee_reports.php">Reports<img src="assets/img/print.png"> </a></li>
124
125 </ul>
126 <br>
127
128 </div>
129 <!--*************************************************************************************************************************-->
130 <div id="page-wrapper">
131 <div class="container-fluid">
132
133
134 <!-- Page Heading -->
135 <nav>
136 <?php
137 $id = $_GET['id'];
138
139 $sql ="SELECT * from studentstable where admission_number='$id' ";
140 $user_query=mysqli_query($db,$sql) or die("error getting data");
141 while($row = mysqli_fetch_array($user_query)){
142 $id = $row['admission_number'];
143 $feepayable = $row['feepayable'];
144 $firstname = $row['firstname'];
145 $class_id= $row['course_id'];
146 }
147 ?>
148
149 <?php
150 //for for that class
151 $id = $_GET['id'];
152 $sql ="SELECT * from course where course_id=
153 (SELECT course_id FROM studentstable
154 WHERE admission_number='$id') ";
155 $user_query=mysqli_query($db,$sql) or die("error getting data");
156 while($row = mysqli_fetch_array($user_query)){
157 $feepayable = $row['feepayable'];
158 }
159 ?>
160
161
162 <?php
163 //check whather the students has paid for that year as you sum up
164 $id=$_GET['id'];
165 $sql="SELECT SUM(amount) AS value_sum FROM fee WHERE
166 admission_number='$id' AND
167 course_id=(SELECT course_id FROM studentstable
168 WHERE admission_number='$id') ";//two conditions here must be met
169 $user_query=mysqli_query($db,$sql) or die("error getting data");
170 while($row = mysqli_fetch_array($user_query)){
171
172 $totalpaid= $row['value_sum'];
173 }?>
174
175 <!-- block -->
176 <div id="block_bg" class="block">
177 <div class="navbar navbar-inner block-header">
178
179
180 <form method="get" action="reports_all/pdf.php">
181 <table>
182 <tr><td>
183 <input type="hidden" name="payment" value="<?php echo $id ?>" ></td>
184
185 </form>
186 </tr></table>
187
188
189 <strong>Student's Name: <?php echo $firstname; ?>, fee payable: <?php echo $feepayable; ?>, Amount paid: <?php echo $totalpaid; ?>[ Current Class: Form/Course Code <?php echo $class_id ?> ]</strong>
190
191 <div class="block-content collapse in">
192 <div class="span12">
193
194 <form method="post">
195 <div class="table-responsive">
196 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
197
198 <thead>
199 <tr>
200 <th></th>
201 <th><center>Reciept #.</center></th>
202 <th><center>Method</center></th>
203 <th><center>Ref #</center></th>
204 <th><center>Date</center></th>
205 <th><center>Class</center></th>
206 <th><center>Term</center></th>
207 <th><center>Amount</center></th>
208
209
210 <script src="assets/js/jquery.dataTables.min.js"></script>
211 <script src="assets/js/DT_bootstrap.js"></script>
212 <th></th>
213 </tr>
214 </thead>
215 <tbody>
216 <?php
217
218 $id=$_GET['id'];
219 $sql ="SELECT * from fee where admission_number='$id' ";
220 $user_query=mysqli_query($db,$sql) or die("error getting data");
221 while($row = mysqli_fetch_array($user_query)){
222 $id = $row['admission_number'];
223
224 ?>
225 <tr>
226 <td width="30">
227 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" value="<?php echo $id; ?>">
228 </td>
229 <td><center><?php echo $row['reciept']; ?></center></td>
230 <td><center><?php echo $row['method']; ?></center></td>
231 <td><center><?php echo $row['refno']; ?></center></td>
232 <td><center><?php echo $row['tdate']; ?></center></td>
233 <td><center><?php echo $row['course_id']; ?></center></td>
234 <td><center><?php echo $row['term_id']; ?></center></td>
235 <td><center><?php echo $row['amount']; ?></center></td>
236
237
238
239 </tr>
240 <?php } ?>
241 </tbody>
242 </table>
243 </form>
244
245
246 </div>
247 </div>
248 </div>
249 </div>
250 <!-- /.container-fluid -->
251
252 </div>
253 <!-- /#page-wrapper -->
254 </div>
255 <!--*********************************************************************************-->
256 <div class="col-md-12" style="background-color:#526F35; bottom:0px;position:fixed;">
257 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
258 </div>
259 <script src="assets/js/jquery.min.js"></script>
260 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
261 <script src="assets/js/affix.js"></script>
262 <script src="assets/js/alert.js"></script>
263 <script src="assets/js/alert1.js"></script>
264 <script src="assets/js/bootstrap.js"></script>
265 <script src="assets/js/bootstrap.min.js"></script>
266 <script src="assets/js/bootstrap-datepicker.js"></script>
267 <script src="assets/js/bootstrap-wysihtml5.js"></script>
268 <script src="assets/js/button.js"></script>
269 <script src="assets/js/carousel.js"></script>
270 <script src="assets/js/chosen.jquery.min.js"></script>
271 <script src="assets/js/ckeditor.js"></script>
272 <script src="assets/js/collapse.js"></script>
273 <script src="assets/js/color.js"></script>
274 <script src="assets/js/dropdown.js"></script>
275 <script src="assets/js/DT_bootstrap.js"></script>
276 <script src="assets/js/dynamic.js"></script>
277 <script src="assets/js/ie-emulation-modes-warning.js"></script>
278 <script src="assets/js/jquery.dataTables.js"></script>
279 <script src="assets/js/jquery.dataTables.min.js"></script>
280 <script src="assets/js/jquery.dialog.js"></script>
281 <script src="assets/js/jquery.hoverdir.js"></script>
282 <script src="assets/js/jquery.jgrowl.js"></script>
283 <script src="assets/js/jquery.knob.js"></script>
284 <script src="assets/js/jquery.uniform.min.js"></script>
285 <script src="assets/js/jquery-1.8.3.min.js"></script>
286 <script src="assets/js/jquery-1.9.1.js"></script>
287 <script src="assets/js/jquery-1.9.1.min.js"></script>
288 <script src="assets/js/jquery-1.10.2.js"></script>
289 <script src="assets/js/jquery-1.11.0.js"></script>
290 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
291 <script src="assets/js/jquery-ui-1.10.3.js"></script>
292 <script src="assets/js/modal.js"></script>
293 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
294 <script src="assets/js/myjquery.js"></script>
295 <script src="assets/js/myjquery1.js"></script>
296 <script src="assets/js/npm.js"></script>
297 <script src="assets/js/popover.js"></script>
298 <script src="assets/js/profile.js"></script>
299 <script src="assets/js/raphael-min.js"></script>
300 <script src="assets/js/sb-admin-2.js"></script>
301 <script src="assets/js/scripts.js"></script>
302 <script src="assets/js/scrollspy.js"></script>
303 <script src="assets/js/tab.js"></script>
304 <script src="assets/js/tooltip.js"></script>
305 <script src="assets/js/transition.js"></script>
306 <script src="assets/js/wysihtml5-0.3.0.js"></script>
307 <script language="javascript" type="text/javascript">
308 $(window).load(function()
309 {
310 $('#loading').hide();
311 });
312 </script>
313 </body>
314
315 </html>